databaseChangeLog = {

	changeSet(author: "mark (generated)", id: "1361475486954-1") {
		createTable(tableName: "track_back") {
			column(autoIncrement: "true", name: "id", type: "BIGINT") {
				constraints(nullable: "false", primaryKey: "true")
			}

			column(name: "version", type: "BIGINT") {
				constraints(nullable: "false")
			}

			column(name: "event_id", type: "BIGINT") {
				constraints(nullable: "false")
			}

			column(name: "loc_lat", type: "FLOAT")

			column(name: "loc_long", type: "FLOAT")

			column(name: "location", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "venue", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "track_idx", type: "INT")

			column(name: "room", type: "VARCHAR(255)")
		}
	}

	changeSet(author: "mark (generated)", id: "1361475486954-2") {
		addForeignKeyConstraint(baseColumnNames: "event_id", baseTableName: "track_back", baseTableSchemaName: "pijunn", constraintName: "FK451AE35B2CE76BD9", deferrable: "false", initiallyDeferred: "false", onDelete: "NO ACTION", onUpdate: "NO ACTION", referencedColumnNames: "id", referencedTableName: "lost_event", referencedTableSchemaName: "pijunn", referencesUniqueColumn: "false")
	}

	changeSet(author: "mark (generated)", id: "1361475486954-3") {
		dropColumn(columnName: "loc_lat", tableName: "lost_event")
	}

	changeSet(author: "mark (generated)", id: "1361475486954-4") {
		dropColumn(columnName: "loc_long", tableName: "lost_event")
	}

	changeSet(author: "mark (generated)", id: "1361475486954-5") {
		dropColumn(columnName: "location", tableName: "lost_event")
	}

	changeSet(author: "mark (generated)", id: "1361475486954-6") {
		dropColumn(columnName: "venue", tableName: "lost_event")
	}
}
